Pandas Profiling Report

Dataset statistics

Number of variables	23
Number of observations	100000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	45
Duplicate rows (%)	< 0.1%
Total size in memory	17.5 MiB
Average record size in memory	184.0 B

Variable types

Categorical	12
Numeric	11

Alerts

Dataset has 45 (< 0.1%) duplicate rows	Duplicates
`category` is highly overall correlated with `cost` and 6 other fields	High correlation
`cost` is highly overall correlated with `category` and 7 other fields	High correlation
`current_price` is highly overall correlated with `profit_margin` and 3 other fields	High correlation
`discount_pct` is highly overall correlated with `ratio`	High correlation
`gender` is highly overall correlated with `category` and 4 other fields	High correlation
`has_extra_sizes` is highly overall correlated with `category` and 4 other fields	High correlation
`main_color` is highly overall correlated with `category` and 6 other fields	High correlation
`month` is highly overall correlated with `week_number`	High correlation
`productgroup` is highly overall correlated with `category` and 3 other fields	High correlation
`profit_margin` is highly overall correlated with `cost` and 4 other fields	High correlation
`promo1` is highly overall correlated with `week_number`	High correlation
`ratio` is highly overall correlated with `discount_pct`	High correlation
`regular_price` is highly overall correlated with `current_price` and 3 other fields	High correlation
`sales` is highly overall correlated with `total_profit`	High correlation
`sec_color` is highly overall correlated with `category` and 4 other fields	High correlation
`style` is highly overall correlated with `category` and 3 other fields	High correlation
`total_profit` is highly overall correlated with `current_price` and 4 other fields	High correlation
`unit_profit` is highly overall correlated with `current_price` and 3 other fields	High correlation
`week_number` is highly overall correlated with `month` and 1 other fields	High correlation
`has_extra_sizes` is highly imbalanced (53.1%)	Imbalance
`promo1` is highly imbalanced (66.5%)	Imbalance
`promo2` is highly imbalanced (95.5%)	Imbalance
`main_color` is uniformly distributed	Uniform
`discount_pct` has 1490 (1.5%) zeros	Zeros

Reproduction

Analysis started	2025-05-08 09:55:12.561540
Analysis finished	2025-05-08 09:55:32.174361
Duration	19.61 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

country
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Germany	49400
Austria	35140
France	15460

Length

Max length	7
Median length	7
Mean length	6.8454
Min length	6

Characters and Unicode

Total characters	684540
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Germany
2nd row	Germany
3rd row	Germany
4th row	Germany
5th row	Germany

Common Values

Value	Count	Frequency (%)
Germany	49400	49.4%
Austria	35140	35.1%
France	15460	15.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
germany	49400	49.4%
austria	35140	35.1%
france	15460	15.5%

Most occurring characters

Value	Count	Frequency (%)
r	100000	14.6%
a	100000	14.6%
e	64860	9.5%
n	64860	9.5%
G	49400	7.2%
m	49400	7.2%
y	49400	7.2%
A	35140	5.1%
u	35140	5.1%
s	35140	5.1%
Other values (4)	101200	14.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	684540	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	100000	14.6%
a	100000	14.6%
e	64860	9.5%
n	64860	9.5%
G	49400	7.2%
m	49400	7.2%
y	49400	7.2%
A	35140	5.1%
u	35140	5.1%
s	35140	5.1%
Other values (4)	101200	14.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	684540	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	100000	14.6%
a	100000	14.6%
e	64860	9.5%
n	64860	9.5%
G	49400	7.2%
m	49400	7.2%
y	49400	7.2%
A	35140	5.1%
u	35140	5.1%
s	35140	5.1%
Other values (4)	101200	14.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	684540	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	100000	14.6%
a	100000	14.6%
e	64860	9.5%
n	64860	9.5%
G	49400	7.2%
m	49400	7.2%
y	49400	7.2%
A	35140	5.1%
u	35140	5.1%
s	35140	5.1%
Other values (4)	101200	14.8%

productgroup
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

SHOES	60000
HARDWARE ACCESSORIES	20000
SHORTS	10000
SWEATSHIRTS	10000

Length

Max length	20
Median length	5
Mean length	8.7
Min length	5

Characters and Unicode

Total characters	870000
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SHOES
2nd row	SHORTS
3rd row	HARDWARE ACCESSORIES
4th row	SHOES
5th row	SHOES

Common Values

Value	Count	Frequency (%)
SHOES	60000	60.0%
HARDWARE ACCESSORIES	20000	20.0%
SHORTS	10000	10.0%
SWEATSHIRTS	10000	10.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
shoes	60000	50.0%
hardware	20000	16.7%
accessories	20000	16.7%
shorts	10000	8.3%
sweatshirts	10000	8.3%

Most occurring characters

Value	Count	Frequency (%)
S	230000	26.4%
E	130000	14.9%
H	100000	11.5%
O	90000	10.3%
R	80000	9.2%
A	70000	8.0%
C	40000	4.6%
W	30000	3.4%
I	30000	3.4%
T	30000	3.4%
Other values (2)	40000	4.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	870000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	230000	26.4%
E	130000	14.9%
H	100000	11.5%
O	90000	10.3%
R	80000	9.2%
A	70000	8.0%
C	40000	4.6%
W	30000	3.4%
I	30000	3.4%
T	30000	3.4%
Other values (2)	40000	4.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	870000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	230000	26.4%
E	130000	14.9%
H	100000	11.5%
O	90000	10.3%
R	80000	9.2%
A	70000	8.0%
C	40000	4.6%
W	30000	3.4%
I	30000	3.4%
T	30000	3.4%
Other values (2)	40000	4.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	870000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	230000	26.4%
E	130000	14.9%
H	100000	11.5%
O	90000	10.3%
R	80000	9.2%
A	70000	8.0%
C	40000	4.6%
W	30000	3.4%
I	30000	3.4%
T	30000	3.4%
Other values (2)	40000	4.6%

category
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

TRAINING	30000
RUNNING	20000
FOOTBALL GENERIC	20000
GOLF	10000
RELAX CASUAL	10000

Length

Max length	16
Median length	10
Mean length	9.2
Min length	4

Characters and Unicode

Total characters	920000
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TRAINING
2nd row	TRAINING
3rd row	GOLF
4th row	RUNNING
5th row	RELAX CASUAL

Common Values

Value	Count	Frequency (%)
TRAINING	30000	30.0%
RUNNING	20000	20.0%
FOOTBALL GENERIC	20000	20.0%
GOLF	10000	10.0%
RELAX CASUAL	10000	10.0%
INDOOR	10000	10.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
training	30000	23.1%
running	20000	15.4%
football	20000	15.4%
generic	20000	15.4%
golf	10000	7.7%
relax	10000	7.7%
casual	10000	7.7%
indoor	10000	7.7%

Most occurring characters

Value	Count	Frequency (%)
N	150000	16.3%
I	110000	12.0%
R	90000	9.8%
A	80000	8.7%
G	80000	8.7%
O	70000	7.6%
L	70000	7.6%
E	50000	5.4%
T	50000	5.4%
F	30000	3.3%
Other values (7)	140000	15.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	920000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	150000	16.3%
I	110000	12.0%
R	90000	9.8%
A	80000	8.7%
G	80000	8.7%
O	70000	7.6%
L	70000	7.6%
E	50000	5.4%
T	50000	5.4%
F	30000	3.3%
Other values (7)	140000	15.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	920000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	150000	16.3%
I	110000	12.0%
R	90000	9.8%
A	80000	8.7%
G	80000	8.7%
O	70000	7.6%
L	70000	7.6%
E	50000	5.4%
T	50000	5.4%
F	30000	3.3%
Other values (7)	140000	15.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	920000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	150000	16.3%
I	110000	12.0%
R	90000	9.8%
A	80000	8.7%
G	80000	8.7%
O	70000	7.6%
L	70000	7.6%
E	50000	5.4%
T	50000	5.4%
F	30000	3.3%
Other values (7)	140000	15.2%

style
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

regular	50000
wide	30000
slim	20000

Length

Max length	7
Median length	5.5
Mean length	5.5
Min length	4

Characters and Unicode

Total characters	550000
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	slim
2nd row	regular
3rd row	regular
4th row	regular
5th row	regular

Common Values

Value	Count	Frequency (%)
regular	50000	50.0%
wide	30000	30.0%
slim	20000	20.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
regular	50000	50.0%
wide	30000	30.0%
slim	20000	20.0%

Most occurring characters

Value	Count	Frequency (%)
r	100000	18.2%
e	80000	14.5%
l	70000	12.7%
g	50000	9.1%
u	50000	9.1%
a	50000	9.1%
i	50000	9.1%
w	30000	5.5%
d	30000	5.5%
s	20000	3.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	550000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	100000	18.2%
e	80000	14.5%
l	70000	12.7%
g	50000	9.1%
u	50000	9.1%
a	50000	9.1%
i	50000	9.1%
w	30000	5.5%
d	30000	5.5%
s	20000	3.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	550000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	100000	18.2%
e	80000	14.5%
l	70000	12.7%
g	50000	9.1%
u	50000	9.1%
a	50000	9.1%
i	50000	9.1%
w	30000	5.5%
d	30000	5.5%
s	20000	3.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	550000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	100000	18.2%
e	80000	14.5%
l	70000	12.7%
g	50000	9.1%
u	50000	9.1%
a	50000	9.1%
i	50000	9.1%
w	30000	5.5%
d	30000	5.5%
s	20000	3.6%

gender
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

women	70000
kids	10000
unisex	10000
men	10000

Length

Max length	6
Median length	5
Mean length	4.8
Min length	3

Characters and Unicode

Total characters	480000
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	women
2nd row	women
3rd row	women
4th row	kids
5th row	women

Common Values

Value	Count	Frequency (%)
women	70000	70.0%
kids	10000	10.0%
unisex	10000	10.0%
men	10000	10.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
women	70000	70.0%
kids	10000	10.0%
unisex	10000	10.0%
men	10000	10.0%

Most occurring characters

Value	Count	Frequency (%)
e	90000	18.8%
n	90000	18.8%
m	80000	16.7%
w	70000	14.6%
o	70000	14.6%
i	20000	4.2%
s	20000	4.2%
k	10000	2.1%
d	10000	2.1%
u	10000	2.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	480000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	90000	18.8%
n	90000	18.8%
m	80000	16.7%
w	70000	14.6%
o	70000	14.6%
i	20000	4.2%
s	20000	4.2%
k	10000	2.1%
d	10000	2.1%
u	10000	2.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	480000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	90000	18.8%
n	90000	18.8%
m	80000	16.7%
w	70000	14.6%
o	70000	14.6%
i	20000	4.2%
s	20000	4.2%
k	10000	2.1%
d	10000	2.1%
u	10000	2.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	480000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	90000	18.8%
n	90000	18.8%
m	80000	16.7%
w	70000	14.6%
o	70000	14.6%
i	20000	4.2%
s	20000	4.2%
k	10000	2.1%
d	10000	2.1%
u	10000	2.1%

main_color
Categorical

HIGH CORRELATION UNIFORM

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

chocolate	10000
darkkhaki	10000
goldenrod	10000
rosybrown	10000
blueviolet	10000
Other values (5)	50000

Length

Max length	12
Median length	11
Mean length	8.2
Min length	4

Characters and Unicode

Total characters	820000
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	chocolate
2nd row	darkkhaki
3rd row	goldenrod
4th row	rosybrown
5th row	blueviolet

Common Values

Value	Count	Frequency (%)
chocolate	10000	10.0%
darkkhaki	10000	10.0%
goldenrod	10000	10.0%
rosybrown	10000	10.0%
blueviolet	10000	10.0%
steelblue	10000	10.0%
brown	10000	10.0%
lightskyblue	10000	10.0%
silver	10000	10.0%
gray	10000	10.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
chocolate	10000	10.0%
darkkhaki	10000	10.0%
goldenrod	10000	10.0%
rosybrown	10000	10.0%
blueviolet	10000	10.0%
steelblue	10000	10.0%
brown	10000	10.0%
lightskyblue	10000	10.0%
silver	10000	10.0%
gray	10000	10.0%

Most occurring characters

Value	Count	Frequency (%)
l	90000	11.0%
e	90000	11.0%
o	80000	9.8%
r	70000	8.5%
b	50000	6.1%
k	40000	4.9%
a	40000	4.9%
t	40000	4.9%
i	40000	4.9%
s	40000	4.9%
Other values (9)	240000	29.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	820000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	90000	11.0%
e	90000	11.0%
o	80000	9.8%
r	70000	8.5%
b	50000	6.1%
k	40000	4.9%
a	40000	4.9%
t	40000	4.9%
i	40000	4.9%
s	40000	4.9%
Other values (9)	240000	29.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	820000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	90000	11.0%
e	90000	11.0%
o	80000	9.8%
r	70000	8.5%
b	50000	6.1%
k	40000	4.9%
a	40000	4.9%
t	40000	4.9%
i	40000	4.9%
s	40000	4.9%
Other values (9)	240000	29.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	820000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	90000	11.0%
e	90000	11.0%
o	80000	9.8%
r	70000	8.5%
b	50000	6.1%
k	40000	4.9%
a	40000	4.9%
t	40000	4.9%
i	40000	4.9%
s	40000	4.9%
Other values (9)	240000	29.3%

sec_color
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

rosybrown	40000
lavender	30000
lightblue	30000

Length

Max length	9
Median length	9
Mean length	8.7
Min length	8

Characters and Unicode

Total characters	870000
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	lavender
2nd row	lavender
3rd row	lavender
4th row	lightblue
5th row	lightblue

Common Values

Value	Count	Frequency (%)
rosybrown	40000	40.0%
lavender	30000	30.0%
lightblue	30000	30.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rosybrown	40000	40.0%
lavender	30000	30.0%
lightblue	30000	30.0%

Most occurring characters

Value	Count	Frequency (%)
r	110000	12.6%
l	90000	10.3%
e	90000	10.3%
o	80000	9.2%
b	70000	8.0%
n	70000	8.0%
s	40000	4.6%
y	40000	4.6%
w	40000	4.6%
g	30000	3.4%
Other values (7)	210000	24.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	870000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	110000	12.6%
l	90000	10.3%
e	90000	10.3%
o	80000	9.2%
b	70000	8.0%
n	70000	8.0%
s	40000	4.6%
y	40000	4.6%
w	40000	4.6%
g	30000	3.4%
Other values (7)	210000	24.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	870000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	110000	12.6%
l	90000	10.3%
e	90000	10.3%
o	80000	9.2%
b	70000	8.0%
n	70000	8.0%
s	40000	4.6%
y	40000	4.6%
w	40000	4.6%
g	30000	3.4%
Other values (7)	210000	24.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	870000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	110000	12.6%
l	90000	10.3%
e	90000	10.3%
o	80000	9.2%
b	70000	8.0%
n	70000	8.0%
s	40000	4.6%
y	40000	4.6%
w	40000	4.6%
g	30000	3.4%
Other values (7)	210000	24.1%

has_extra_sizes
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

1	90000
0	10000

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	100000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	90000	90.0%
0	10000	10.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	90000	90.0%
0	10000	10.0%

Most occurring characters

Value	Count	Frequency (%)
1	90000	90.0%
0	10000	10.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	90000	90.0%
0	10000	10.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	90000	90.0%
0	10000	10.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	90000	90.0%
0	10000	10.0%

year
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

2015	42790
2016	41830
2017	14600
2014	780

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	400000
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2016
2nd row	2016
3rd row	2016
4th row	2016
5th row	2016

Common Values

Value	Count	Frequency (%)
2015	42790	42.8%
2016	41830	41.8%
2017	14600	14.6%
2014	780	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2015	42790	42.8%
2016	41830	41.8%
2017	14600	14.6%
2014	780	0.8%

Most occurring characters

Value	Count	Frequency (%)
2	100000	25.0%
0	100000	25.0%
1	100000	25.0%
5	42790	10.7%
6	41830	10.5%
7	14600	3.6%
4	780	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	400000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	100000	25.0%
0	100000	25.0%
1	100000	25.0%
5	42790	10.7%
6	41830	10.5%
7	14600	3.6%
4	780	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	400000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	100000	25.0%
0	100000	25.0%
1	100000	25.0%
5	42790	10.7%
6	41830	10.5%
7	14600	3.6%
4	780	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	400000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	100000	25.0%
0	100000	25.0%
1	100000	25.0%
5	42790	10.7%
6	41830	10.5%
7	14600	3.6%
4	780	0.2%

month
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.9056

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.5312623
Coefficient of variation (CV)	0.59795148
Kurtosis	-1.2258352
Mean	5.9056
Median Absolute Deviation (MAD)	3
Skewness	0.23810075
Sum	590560
Variance	12.469813
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	11730	11.7%
4	10680	10.7%
3	10190	10.2%
2	9980	10.0%
5	8540	8.5%
11	7550	7.5%
10	7100	7.1%
12	7080	7.1%
8	7080	7.1%
7	7010	7.0%
Other values (2)	13060	13.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11730	11.7%
2	9980	10.0%
3	10190	10.2%
4	10680	10.7%
5	8540	8.5%
6	6460	6.5%
7	7010	7.0%
8	7080	7.1%
9	6600	6.6%
10	7100	7.1%

Value	Count	Frequency (%)
12	7080	7.1%
11	7550	7.5%
10	7100	7.1%
9	6600	6.6%
8	7080	7.1%
7	7010	7.0%
6	6460	6.5%
5	8540	8.5%
4	10680	10.7%
3	10190	10.2%

week_number
Real number (ℝ)

HIGH CORRELATION

Distinct	53
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.3435

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	10.75
median	22
Q3	38
95-th percentile	50
Maximum	53
Range	52
Interquartile range (IQR)	27.25

Descriptive statistics

Standard deviation	15.614882
Coefficient of variation (CV)	0.64143949
Kurtosis	-1.2276995
Mean	24.3435
Median Absolute Deviation (MAD)	13
Skewness	0.2332201
Sum	2434350
Variance	243.82455
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	2770	2.8%
5	2700	2.7%
4	2650	2.6%
15	2630	2.6%
17	2620	2.6%
9	2580	2.6%
16	2510	2.5%
2	2450	2.5%
6	2450	2.5%
7	2420	2.4%
Other values (43)	74220	74.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2260	2.3%
2	2450	2.5%
3	2770	2.8%
4	2650	2.6%
5	2700	2.7%
6	2450	2.5%
7	2420	2.4%
8	2410	2.4%
9	2580	2.6%
10	2310	2.3%

Value	Count	Frequency (%)
53	740	0.7%
52	2360	2.4%
51	1790	1.8%
50	1520	1.5%
49	1490	1.5%
48	1690	1.7%
47	1960	2.0%
46	1440	1.4%
45	1720	1.7%
44	1520	1.5%

regular_price
Real number (ℝ)

HIGH CORRELATION

Distinct	123
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.3912

Minimum	3.95
Maximum	197.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	3.95
5-th percentile	6.95
Q1	25.95
median	40.95
Q3	79.95
95-th percentile	120.95
Maximum	197.95
Range	194
Interquartile range (IQR)	54

Descriptive statistics

Standard deviation	35.272128
Coefficient of variation (CV)	0.67324527
Kurtosis	0.32235243
Mean	52.3912
Median Absolute Deviation (MAD)	20
Skewness	0.90371157
Sum	5239120
Variance	1244.123
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26.95	3620	3.6%
29.95	3160	3.2%
30.95	3120	3.1%
23.95	3110	3.1%
62.95	2690	2.7%
25.95	2540	2.5%
44.95	2420	2.4%
20.95	2330	2.3%
3.95	2090	2.1%
83.95	1920	1.9%
Other values (113)	73000	73.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.95	2090	2.1%
4.95	570	0.6%
5.95	1270	1.3%
6.95	1330	1.3%
7.95	170	0.2%
8.95	680	0.7%
9.95	510	0.5%
10.95	800	0.8%
11.95	130	0.1%
12.95	190	0.2%

Value	Count	Frequency (%)
197.95	120	0.1%
195.95	160	0.2%
153.95	850	0.9%
150.95	150	0.1%
141.95	90	0.1%
139.95	240	0.2%
136.95	200	0.2%
135.95	270	0.3%
134.95	150	0.1%
132.95	490	0.5%

current_price
Real number (ℝ)

HIGH CORRELATION

Distinct	141
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.2908

Minimum	1.95
Maximum	195.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1.95
5-th percentile	3.95
Q1	11.95
median	20.95
Q3	37.95
95-th percentile	74.95
Maximum	195.95
Range	194
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	22.578343
Coefficient of variation (CV)	0.79808074
Kurtosis	2.9168272
Mean	28.2908
Median Absolute Deviation (MAD)	11
Skewness	1.5474818
Sum	2829080
Variance	509.78155
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.95	3660	3.7%
9.95	3360	3.4%
11.95	3230	3.2%
13.95	3130	3.1%
17.95	2930	2.9%
12.95	2920	2.9%
16.95	2890	2.9%
15.95	2720	2.7%
7.95	2670	2.7%
14.95	2520	2.5%
Other values (131)	69970	70.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.95	1730	1.7%
2.95	1990	2.0%
3.95	1420	1.4%
4.95	1650	1.7%
5.95	1960	2.0%
6.95	2160	2.2%
7.95	2670	2.7%
8.95	3660	3.7%
9.95	3360	3.4%
10.95	2400	2.4%

Value	Count	Frequency (%)
195.95	10	< 0.1%
178.95	10	< 0.1%
154.95	10	< 0.1%
152.95	20	< 0.1%
145.95	20	< 0.1%
144.95	10	< 0.1%
141.95	10	< 0.1%
140.95	10	< 0.1%
136.95	10	< 0.1%
135.95	10	< 0.1%

ratio
Real number (ℝ)

HIGH CORRELATION

Distinct	2722
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.54564586

Minimum	0.29648241
Maximum	1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0.29648241
5-th percentile	0.30283224
Q1	0.35483871
median	0.52504358
Q3	0.69924812
95-th percentile	0.88868275
Maximum	1
Range	0.70351759
Interquartile range (IQR)	0.34440941

Descriptive statistics

Standard deviation	0.19436278
Coefficient of variation (CV)	0.35620682
Kurtosis	-0.9113374
Mean	0.54564586
Median Absolute Deviation (MAD)	0.17124714
Skewness	0.39778993
Sum	54564.586
Variance	0.03777689
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1490	1.5%
0.4936708861	1140	1.1%
0.3103448276	830	0.8%
0.332096475	820	0.8%
0.3214862682	760	0.8%
0.2988313856	730	0.7%
0.746835443	720	0.7%
0.3319415449	690	0.7%
0.3317422434	570	0.6%
0.3548387097	510	0.5%
Other values (2712)	91740	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2964824121	120	0.1%
0.298245614	230	0.2%
0.2988313856	730	0.7%
0.2991239049	140	0.1%
0.2992992993	160	0.2%
0.2994161802	40	< 0.1%
0.2994996426	310	0.3%
0.2995622264	50	0.1%
0.2996108949	60	0.1%
0.2996498249	70	0.1%

Value	Count	Frequency (%)
1	1490	1.5%
0.9920603414	10	< 0.1%
0.9917321207	10	< 0.1%
0.9915218313	10	< 0.1%
0.9904716532	10	< 0.1%
0.9899949975	10	< 0.1%
0.9890049478	10	< 0.1%
0.9880881477	10	< 0.1%
0.9857040743	20	< 0.1%
0.9841206828	10	< 0.1%

discount_pct
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2722
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.45435414

Minimum	0
Maximum	0.70351759
Zeros	1490
Zeros (%)	1.5%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.11131725
Q1	0.30075188
median	0.47495642
Q3	0.64516129
95-th percentile	0.69716776
Maximum	0.70351759
Range	0.70351759
Interquartile range (IQR)	0.34440941

Descriptive statistics

Standard deviation	0.19436278
Coefficient of variation (CV)	0.42777816
Kurtosis	-0.9113374
Mean	0.45435414
Median Absolute Deviation (MAD)	0.17124714
Skewness	-0.39778993
Sum	45435.414
Variance	0.03777689
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1490	1.5%
0.5063291139	1140	1.1%
0.6896551724	830	0.8%
0.667903525	820	0.8%
0.6785137318	760	0.8%
0.7011686144	730	0.7%
0.253164557	720	0.7%
0.6680584551	690	0.7%
0.6682577566	570	0.6%
0.6451612903	510	0.5%
Other values (2712)	91740	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1490	1.5%
0.007939658595	10	< 0.1%
0.008267879289	10	< 0.1%
0.008478168716	10	< 0.1%
0.009528346832	10	< 0.1%
0.0100050025	10	< 0.1%
0.01099505223	10	< 0.1%
0.01191185229	10	< 0.1%
0.01429592566	20	< 0.1%
0.01587931719	10	< 0.1%

Value	Count	Frequency (%)
0.7035175879	120	0.1%
0.701754386	230	0.2%
0.7011686144	730	0.7%
0.7008760951	140	0.1%
0.7007007007	160	0.2%
0.7005838198	40	< 0.1%
0.7005003574	310	0.3%
0.7004377736	50	0.1%
0.7003891051	60	0.1%
0.7003501751	70	0.1%

cost
Real number (ℝ)

HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.517

Minimum	1.29
Maximum	13.29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1.29
5-th percentile	1.29
Q1	2.29
median	6.95
Q3	9.6
95-th percentile	13.29
Maximum	13.29
Range	12
Interquartile range (IQR)	7.31

Descriptive statistics

Standard deviation	3.9147279
Coefficient of variation (CV)	0.60069478
Kurtosis	-1.2872918
Mean	6.517
Median Absolute Deviation (MAD)	2.85
Skewness	0.099353368
Sum	651700
Variance	15.325094
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
13.29	10000	10.0%
2.29	10000	10.0%
1.7	10000	10.0%
9	10000	10.0%
9.6	10000	10.0%
4.2	10000	10.0%
9.9	10000	10.0%
5.2	10000	10.0%
1.29	10000	10.0%
8.7	10000	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.29	10000	10.0%
1.7	10000	10.0%
2.29	10000	10.0%
4.2	10000	10.0%
5.2	10000	10.0%
8.7	10000	10.0%
9	10000	10.0%
9.6	10000	10.0%
9.9	10000	10.0%
13.29	10000	10.0%

Value	Count	Frequency (%)
13.29	10000	10.0%
9.9	10000	10.0%
9.6	10000	10.0%
9	10000	10.0%
8.7	10000	10.0%
5.2	10000	10.0%
4.2	10000	10.0%
2.29	10000	10.0%
1.7	10000	10.0%
1.29	10000	10.0%

sales
Real number (ℝ)

HIGH CORRELATION

Distinct	476
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.7818

Minimum	1
Maximum	898
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	10
median	26
Q3	64
95-th percentile	216
Maximum	898
Range	897
Interquartile range (IQR)	54

Descriptive statistics

Standard deviation	87.934743
Coefficient of variation (CV)	1.5486431
Kurtosis	20.657374
Mean	56.7818
Median Absolute Deviation (MAD)	20
Skewness	3.8588957
Sum	5678180
Variance	7732.5191
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	3080	3.1%
1	3060	3.1%
3	2950	2.9%
4	2800	2.8%
5	2680	2.7%
6	2670	2.7%
8	2380	2.4%
7	2380	2.4%
9	2160	2.2%
11	2130	2.1%
Other values (466)	73710	73.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3060	3.1%
2	3080	3.1%
3	2950	2.9%
4	2800	2.8%
5	2680	2.7%
6	2670	2.7%
7	2380	2.4%
8	2380	2.4%
9	2160	2.2%
10	1940	1.9%

Value	Count	Frequency (%)
898	10	< 0.1%
883	10	< 0.1%
881	10	< 0.1%
852	10	< 0.1%
841	10	< 0.1%
827	10	< 0.1%
819	10	< 0.1%
818	20	< 0.1%
797	10	< 0.1%
796	10	< 0.1%

unit_profit
Real number (ℝ)

HIGH CORRELATION

Distinct	922
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.7738

Minimum	-11.34
Maximum	194.66
Zeros	0
Zeros (%)	0.0%
Negative	10811
Negative (%)	10.8%
Memory size	781.4 KiB

Quantile statistics

Minimum	-11.34
5-th percentile	-3.34
Q1	5.66
median	15.35
Q3	31.66
95-th percentile	68.75
Maximum	194.66
Range	206
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	22.915206
Coefficient of variation (CV)	1.0524211
Kurtosis	2.747965
Mean	21.7738
Median Absolute Deviation (MAD)	11.69
Skewness	1.4797389
Sum	2177380
Variance	525.10665
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.66	796	0.8%
11.66	785	0.8%
8.66	766	0.8%
12.66	764	0.8%
9.66	753	0.8%
15.66	739	0.7%
14.66	729	0.7%
13.66	723	0.7%
4.66	705	0.7%
7.66	702	0.7%
Other values (912)	92538	92.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-11.34	173	0.2%
-10.34	199	0.2%
-9.34	142	0.1%
-8.34	165	0.2%
-7.95	173	0.2%
-7.65	173	0.2%
-7.34	196	0.2%
-7.05	173	0.2%
-6.95	199	0.2%
-6.75	173	0.2%

Value	Count	Frequency (%)
194.66	1	< 0.1%
194.25	1	< 0.1%
193.66	1	< 0.1%
191.75	1	< 0.1%
190.75	1	< 0.1%
187.25	1	< 0.1%
186.95	1	< 0.1%
186.35	1	< 0.1%
186.05	1	< 0.1%
182.66	1	< 0.1%

total_profit
Real number (ℝ)

HIGH CORRELATION

Distinct	35945
Distinct (%)	35.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	997.09622

Minimum	-9026.64
Maximum	57743.06
Zeros	0
Zeros (%)	0.0%
Negative	10811
Negative (%)	10.8%
Memory size	781.4 KiB

Quantile statistics

Minimum	-9026.64
5-th percentile	-95.42
Q1	73.3
median	316.54
Q3	997.5375
95-th percentile	4347.5275
Maximum	57743.06
Range	66769.7
Interquartile range (IQR)	924.2375

Descriptive statistics

Standard deviation	2258.2682
Coefficient of variation (CV)	2.2648448
Kurtosis	73.025618
Mean	997.09622
Median Absolute Deviation (MAD)	297.9
Skewness	6.4812423
Sum	99709622
Variance	5099775.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
123.75	66	0.1%
78.75	60	0.1%
56.25	60	0.1%
213.75	57	0.1%
173.25	56	0.1%
146.25	56	0.1%
94.5	54	0.1%
57.75	52	0.1%
63	50	0.1%
113.75	49	< 0.1%
Other values (35935)	99440	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9026.64	1	< 0.1%
-7889.42	1	< 0.1%
-7444.8	1	< 0.1%
-6505.2	1	< 0.1%
-6328.2	1	< 0.1%
-6089.4	1	< 0.1%
-6007.54	1	< 0.1%
-5715.36	1	< 0.1%
-5611.8	1	< 0.1%
-5585.74	1	< 0.1%

Value	Count	Frequency (%)
57743.06	1	< 0.1%
57398.25	1	< 0.1%
56902.06	1	< 0.1%
55295.75	1	< 0.1%
54454.75	1	< 0.1%
51511.25	1	< 0.1%
51258.95	1	< 0.1%
50754.35	1	< 0.1%
50502.05	1	< 0.1%
47651.06	1	< 0.1%

profit_margin
Real number (ℝ)

HIGH CORRELATION

Distinct	1410
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.52636619

Minimum	-5.8153846
Maximum	0.99341669
Zeros	0
Zeros (%)	0.0%
Negative	10811
Negative (%)	10.8%
Memory size	781.4 KiB

Quantile statistics

Minimum	-5.8153846
5-th percentile	-0.61344538
Q1	0.44846797
median	0.74965229
Q3	0.88924388
95-th percentile	0.96527068
Maximum	0.99341669
Range	6.8088013
Interquartile range (IQR)	0.44077591

Descriptive statistics

Standard deviation	0.70144356
Coefficient of variation (CV)	1.3326152
Kurtosis	23.922473
Mean	0.52636619
Median Absolute Deviation (MAD)	0.1726778
Skewness	-4.2143305
Sum	52636.619
Variance	0.49202307
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.4849162011	366	0.4%
0.8100558659	366	0.4%
-0.005586592179	366	0.4%
-0.07262569832	366	0.4%
0.530726257	366	0.4%
-0.1061452514	366	0.4%
0.4189944134	366	0.4%
0.8558659218	366	0.4%
0.02793296089	366	0.4%
0.7441340782	366	0.4%
Other values (1400)	96340	96.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-5.815384615	173	0.2%
-4.076923077	173	0.2%
-3.923076923	173	0.2%
-3.615384615	173	0.2%
-3.505084746	199	0.2%
-3.461538462	173	0.2%
-2.364556962	142	0.1%
-2.355932203	199	0.2%
-2.254237288	199	0.2%
-2.050847458	199	0.2%

Value	Count	Frequency (%)
0.9934166879	1	< 0.1%
0.9927912825	1	< 0.1%
0.9916747338	1	< 0.1%
0.9915658712	2	< 0.1%
0.9913243174	1	< 0.1%
0.9911613566	2	< 0.1%
0.9911003794	1	< 0.1%
0.9909122931	1	< 0.1%
0.9908478184	1	< 0.1%
0.9905805038	1	< 0.1%

promo1
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

0	93810
1	6190

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	100000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	93810	93.8%
1	6190	6.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	93810	93.8%
1	6190	6.2%

Most occurring characters

Value	Count	Frequency (%)
0	93810	93.8%
1	6190	6.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	93810	93.8%
1	6190	6.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	93810	93.8%
1	6190	6.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	93810	93.8%
1	6190	6.2%

promo2
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

0	99510
1	490

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	100000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	99510	99.5%
1	490	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	99510	99.5%
1	490	0.5%

Most occurring characters

Value	Count	Frequency (%)
0	99510	99.5%
1	490	0.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	99510	99.5%
1	490	0.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	99510	99.5%
1	490	0.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	99510	99.5%
1	490	0.5%

label
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

0	86072
1	13928

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	100000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	86072	86.1%
1	13928	13.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	86072	86.1%
1	13928	13.9%

Most occurring characters

Value	Count	Frequency (%)
0	86072	86.1%
1	13928	13.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	86072	86.1%
1	13928	13.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	86072	86.1%
1	13928	13.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	86072	86.1%
1	13928	13.9%

Auto

Heatmap
Table

	category	cost	country	current_price	discount_pct	gender	has_extra_sizes	label	main_color	month	productgroup	profit_margin	promo1	promo2	ratio	regular_price	sales	sec_color	style	total_profit	unit_profit	week_number	year
category	1.000	0.699	0.000	0.000	0.000	0.690	0.667	0.005	1.000	0.000	0.638	0.117	0.000	0.000	0.000	0.000	0.000	0.795	0.589	0.012	0.060	0.000	0.000
cost	0.699	1.000	0.000	0.000	0.000	0.724	1.000	0.000	1.000	0.000	0.816	-0.659	0.000	0.000	0.000	0.000	0.000	0.782	0.876	-0.226	-0.225	0.000	0.000
country	0.000	0.000	1.000	0.076	0.043	0.000	0.000	0.010	0.000	0.032	0.000	0.032	0.008	0.164	0.043	0.175	0.026	0.000	0.000	0.019	0.077	0.028	0.014
current_price	0.000	0.000	0.076	1.000	-0.372	0.000	0.000	0.181	0.000	-0.140	0.000	0.706	0.069	0.029	0.372	0.885	-0.178	0.000	0.000	0.592	0.966	-0.127	0.036
discount_pct	0.000	0.000	0.043	-0.372	1.000	0.000	0.000	0.462	0.000	0.339	0.000	-0.256	0.162	0.044	-1.000	0.071	0.435	0.000	0.000	0.042	-0.363	0.312	0.065
gender	0.690	0.724	0.000	0.000	0.000	1.000	1.000	0.000	1.000	0.000	0.309	0.123	0.000	0.000	0.000	0.000	0.000	0.546	0.483	0.008	0.068	0.000	0.000
has_extra_sizes	0.667	1.000	0.000	0.000	0.000	1.000	1.000	0.000	1.000	0.000	0.272	0.141	0.000	0.000	0.000	0.000	0.000	0.408	0.509	0.011	0.070	0.000	0.000
label	0.005	0.000	0.010	0.181	0.462	0.000	0.000	1.000	0.003	0.334	0.000	0.092	0.064	0.020	0.462	0.022	0.099	0.000	0.000	0.015	0.182	0.337	0.039
main_color	1.000	1.000	0.000	0.000	0.000	1.000	1.000	0.003	1.000	0.000	1.000	0.163	0.000	0.000	0.000	0.000	0.000	1.000	1.000	0.020	0.075	0.000	0.000
month	0.000	0.000	0.032	-0.140	0.339	0.000	0.000	0.334	0.000	1.000	0.000	-0.099	0.390	0.091	-0.339	0.006	0.201	0.000	0.000	0.038	-0.137	0.912	0.309
productgroup	0.638	0.816	0.000	0.000	0.000	0.309	0.272	0.000	1.000	0.000	1.000	0.190	0.000	0.000	0.000	0.000	0.000	0.553	0.494	0.026	0.117	0.000	0.000
profit_margin	0.117	-0.659	0.032	0.706	-0.256	0.123	0.141	0.092	0.163	-0.099	0.190	1.000	0.040	0.018	0.256	0.629	-0.123	0.076	0.087	0.586	0.844	-0.089	0.014
promo1	0.000	0.000	0.008	0.069	0.162	0.000	0.000	0.064	0.000	0.390	0.000	0.040	1.000	0.047	0.162	0.016	0.126	0.000	0.000	0.126	0.070	0.521	0.358
promo2	0.000	0.000	0.164	0.029	0.044	0.000	0.000	0.020	0.000	0.091	0.000	0.018	0.047	1.000	0.044	0.028	0.016	0.000	0.000	0.010	0.025	0.088	0.047
ratio	0.000	0.000	0.043	0.372	-1.000	0.000	0.000	0.462	0.000	-0.339	0.000	0.256	0.162	0.044	1.000	-0.071	-0.435	0.000	0.000	-0.042	0.363	-0.312	0.065
regular_price	0.000	0.000	0.175	0.885	0.071	0.000	0.000	0.022	0.000	0.006	0.000	0.629	0.016	0.028	-0.071	1.000	0.011	0.000	0.000	0.653	0.854	0.007	0.020
sales	0.000	0.000	0.026	-0.178	0.435	0.000	0.000	0.099	0.000	0.201	0.000	-0.123	0.126	0.016	-0.435	0.011	1.000	0.000	0.000	0.542	-0.174	0.201	0.052
sec_color	0.795	0.782	0.000	0.000	0.000	0.546	0.408	0.000	1.000	0.000	0.553	0.076	0.000	0.000	0.000	0.000	0.000	1.000	0.400	0.009	0.033	0.000	0.000
style	0.589	0.876	0.000	0.000	0.000	0.483	0.509	0.000	1.000	0.000	0.494	0.087	0.000	0.000	0.000	0.000	0.000	0.400	1.000	0.016	0.005	0.000	0.000
total_profit	0.012	-0.226	0.019	0.592	0.042	0.008	0.011	0.015	0.020	0.038	0.026	0.586	0.126	0.010	-0.042	0.653	0.542	0.009	0.016	1.000	0.633	0.050	0.041
unit_profit	0.060	-0.225	0.077	0.966	-0.363	0.068	0.070	0.182	0.075	-0.137	0.117	0.844	0.070	0.025	0.363	0.854	-0.174	0.033	0.005	0.633	1.000	-0.124	0.030
week_number	0.000	0.000	0.028	-0.127	0.312	0.000	0.000	0.337	0.000	0.912	0.000	-0.089	0.521	0.088	-0.312	0.007	0.201	0.000	0.000	0.050	-0.124	1.000	0.292
year	0.000	0.000	0.014	0.036	0.065	0.000	0.000	0.039	0.000	0.309	0.000	0.014	0.358	0.047	0.065	0.020	0.052	0.000	0.000	0.041	0.030	0.292	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	country	productgroup	category	style	gender	main_color	sec_color	has_extra_sizes	year	month	week_number	regular_price	current_price	ratio	discount_pct	cost	sales	unit_profit	total_profit	profit_margin	label
0	Germany	SHOES	TRAINING	slim	women	chocolate	lavender	1	2016	3	12	5.95	3.95	0.663866	0.336134	13.29	28	-9.34	-261.52	-2.364557	0
1	Germany	SHORTS	TRAINING	regular	women	darkkhaki	lavender	1	2016	3	12	5.95	3.95	0.663866	0.336134	2.29	28	1.66	46.48	0.420253	0
2	Germany	HARDWARE ACCESSORIES	GOLF	regular	women	goldenrod	lavender	1	2016	3	12	5.95	3.95	0.663866	0.336134	1.70	28	2.25	63.00	0.569620	0
3	Germany	SHOES	RUNNING	regular	kids	rosybrown	lightblue	1	2016	3	12	5.95	3.95	0.663866	0.336134	9.00	28	-5.05	-141.40	-1.278481	0
4	Germany	SHOES	RELAX CASUAL	regular	women	blueviolet	lightblue	1	2016	3	12	5.95	3.95	0.663866	0.336134	9.60	28	-5.65	-158.20	-1.430380	0
5	Germany	SWEATSHIRTS	TRAINING	wide	women	steelblue	lightblue	1	2016	3	12	5.95	3.95	0.663866	0.336134	4.20	28	-0.25	-7.00	-0.063291	1
6	Germany	SHOES	FOOTBALL GENERIC	wide	unisex	brown	rosybrown	0	2016	3	12	5.95	3.95	0.663866	0.336134	9.90	28	-5.95	-166.60	-1.506329	0
7	Germany	SHOES	INDOOR	wide	women	lightskyblue	rosybrown	1	2016	3	12	5.95	3.95	0.663866	0.336134	5.20	28	-1.25	-35.00	-0.316456	1
8	Germany	HARDWARE ACCESSORIES	RUNNING	slim	women	silver	rosybrown	1	2016	3	12	5.95	3.95	0.663866	0.336134	1.29	28	2.66	74.48	0.673418	0
9	Germany	SHOES	FOOTBALL GENERIC	regular	men	gray	rosybrown	1	2016	3	12	5.95	3.95	0.663866	0.336134	8.70	28	-4.75	-133.00	-1.202532	1

	country	productgroup	category	style	gender	main_color	sec_color	has_extra_sizes	year	month	week_number	regular_price	current_price	ratio	discount_pct	cost	sales	unit_profit	total_profit	profit_margin
99990	Germany	SHOES	TRAINING	slim	women	chocolate	lavender	1	2016	6	25	57.95	26.95	0.465056	0.534944	13.29	227	13.66	3100.82	0.506865
99991	Germany	SHORTS	TRAINING	regular	women	darkkhaki	lavender	1	2016	6	25	57.95	26.95	0.465056	0.534944	2.29	227	24.66	5597.82	0.915028
99992	Germany	HARDWARE ACCESSORIES	GOLF	regular	women	goldenrod	lavender	1	2016	6	25	57.95	26.95	0.465056	0.534944	1.70	227	25.25	5731.75	0.936920
99993	Germany	SHOES	RUNNING	regular	kids	rosybrown	lightblue	1	2016	6	25	57.95	26.95	0.465056	0.534944	9.00	227	17.95	4074.65	0.666048
99994	Germany	SHOES	RELAX CASUAL	regular	women	blueviolet	lightblue	1	2016	6	25	57.95	26.95	0.465056	0.534944	9.60	227	17.35	3938.45	0.643785
99995	Germany	SWEATSHIRTS	TRAINING	wide	women	steelblue	lightblue	1	2016	6	25	57.95	26.95	0.465056	0.534944	4.20	227	22.75	5164.25	0.844156
99996	Germany	SHOES	FOOTBALL GENERIC	wide	unisex	brown	rosybrown	0	2016	6	25	57.95	26.95	0.465056	0.534944	9.90	227	17.05	3870.35	0.632653
99997	Germany	SHOES	INDOOR	wide	women	lightskyblue	rosybrown	1	2016	6	25	57.95	26.95	0.465056	0.534944	5.20	227	21.75	4937.25	0.807050
99998	Germany	HARDWARE ACCESSORIES	RUNNING	slim	women	silver	rosybrown	1	2016	6	25	57.95	26.95	0.465056	0.534944	1.29	227	25.66	5824.82	0.952134
99999	Germany	SHOES	FOOTBALL GENERIC	regular	men	gray	rosybrown	1	2016	6	25	57.95	26.95	0.465056	0.534944	8.70	227	18.25	4142.75	0.677180

Most frequently occurring

	country	productgroup	category	style	gender	main_color	sec_color	has_extra_sizes	year	month	week_number	regular_price	current_price	ratio	discount_pct	cost	sales	unit_profit	total_profit	profit_margin	# duplicates
0	Austria	HARDWARE ACCESSORIES	GOLF	regular	women	goldenrod	lavender	1	2016	7	27	3.95	1.95	0.493671	0.506329	1.70	8	0.25	2.00	0.128205	2
1	Austria	HARDWARE ACCESSORIES	RUNNING	slim	women	silver	rosybrown	1	2016	7	27	3.95	1.95	0.493671	0.506329	1.29	8	0.66	5.28	0.338462	2
2	Austria	SHOES	FOOTBALL GENERIC	regular	men	gray	rosybrown	1	2016	7	27	3.95	1.95	0.493671	0.506329	8.70	8	-6.75	-54.00	-3.461538	2
3	Austria	SHOES	FOOTBALL GENERIC	wide	unisex	brown	rosybrown	0	2016	7	27	3.95	1.95	0.493671	0.506329	9.90	8	-7.95	-63.60	-4.076923	2
4	Austria	SHOES	INDOOR	wide	women	lightskyblue	rosybrown	1	2016	7	27	3.95	1.95	0.493671	0.506329	5.20	8	-3.25	-26.00	-1.666667	2
5	Austria	SHOES	RELAX CASUAL	regular	women	blueviolet	lightblue	1	2016	7	27	3.95	1.95	0.493671	0.506329	9.60	8	-7.65	-61.20	-3.923077	2
6	Austria	SHOES	RUNNING	regular	kids	rosybrown	lightblue	1	2016	7	27	3.95	1.95	0.493671	0.506329	9.00	8	-7.05	-56.40	-3.615385	2
7	Austria	SHOES	TRAINING	slim	women	chocolate	lavender	1	2016	7	27	3.95	1.95	0.493671	0.506329	13.29	8	-11.34	-90.72	-5.815385	2
8	Austria	SHORTS	TRAINING	regular	women	darkkhaki	lavender	1	2016	7	27	3.95	1.95	0.493671	0.506329	2.29	8	-0.34	-2.72	-0.174359	2
9	Austria	SWEATSHIRTS	TRAINING	wide	women	steelblue	lightblue	1	2016	7	27	3.95	1.95	0.493671	0.506329	4.20	8	-2.25	-18.00	-1.153846	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)